<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="UTF-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Document</title>
</head>

<body>

</body>
<script>
  const list = [
    {
      correctionTime: "2018-11-30",
      departmentName: "总裁办",
      formOfEmployment: 1,
      id: "604f764971f93f3ac8f365c2",
      mobile: "13800000002",
      password: "e10adc3949ba59abbe56e057f20f883e",
      staffPhoto: "http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907",
      timeOfEntry: "2018-11-02",
      username: "管理员",
      workNumber: "9002",
    },
    {
      correctionTime: "2018-11-20",
      departmentName: "市场部",
      formOfEmployment: 1,
      id: "604f764971f93f3ac8f365c3",
      mobile: "13800000003",
      password: "e10adc3949ba59abbe56e057f20f883e",
      staffPhoto: "http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907",
      timeOfEntry: "2018-11-04",
      username: "孙财",
      workNumber: "111",
    }
  ]



  function dataEnToeccel(list) {
    const mapInfo = {
      'id': '编号',
      'password': '密码',
      'mobile': '手机号',
      'username': '姓名',
      'timeOfEntry': '入职日期',
      'formOfEmployment': '聘用形式',
      'correctionTime': '转正日期',
      'workNumber': '工号',
      'departmentName': '部门',
      'staffPhoto': '头像地址'
    }


    const one = list[0]  // 返回的有没有数据，没有数据就是undefined
    if (!one) return

    //  console.log(ehkey);
    // 1.拿到表头
    const header = Object.keys(one).map(item => {
      return mapInfo[item]
    })
    // console.log(header);
    //  2.生成表的内容 data
    const data = list.map(item => {
      return Object.values(item)
    })
    return { header, data }
  }
  const {header, data} = dataEnToeccel(list)
  console.log(header, data);
</script>

</html>